/**
 * This file is part of mycollab-services.
 *
 * mycollab-services is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * mycollab-services is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with mycollab-services.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.mycollab.module.crm.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@SuppressWarnings("ucd")
public class LeadExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public LeadExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCampaignidIsNull() {
            addCriterion("campaignId is null");
            return (Criteria) this;
        }

        public Criteria andCampaignidIsNotNull() {
            addCriterion("campaignId is not null");
            return (Criteria) this;
        }

        public Criteria andCampaignidEqualTo(Integer value) {
            addCriterion("campaignId =", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidNotEqualTo(Integer value) {
            addCriterion("campaignId <>", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidGreaterThan(Integer value) {
            addCriterion("campaignId >", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidGreaterThanOrEqualTo(Integer value) {
            addCriterion("campaignId >=", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidLessThan(Integer value) {
            addCriterion("campaignId <", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidLessThanOrEqualTo(Integer value) {
            addCriterion("campaignId <=", value, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidIn(List<Integer> values) {
            addCriterion("campaignId in", values, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidNotIn(List<Integer> values) {
            addCriterion("campaignId not in", values, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidBetween(Integer value1, Integer value2) {
            addCriterion("campaignId between", value1, value2, "campaignid");
            return (Criteria) this;
        }

        public Criteria andCampaignidNotBetween(Integer value1, Integer value2) {
            addCriterion("campaignId not between", value1, value2, "campaignid");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescIsNull() {
            addCriterion("leadSourceDesc is null");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescIsNotNull() {
            addCriterion("leadSourceDesc is not null");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescEqualTo(String value) {
            addCriterion("leadSourceDesc =", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescNotEqualTo(String value) {
            addCriterion("leadSourceDesc <>", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescGreaterThan(String value) {
            addCriterion("leadSourceDesc >", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescGreaterThanOrEqualTo(String value) {
            addCriterion("leadSourceDesc >=", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescLessThan(String value) {
            addCriterion("leadSourceDesc <", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescLessThanOrEqualTo(String value) {
            addCriterion("leadSourceDesc <=", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescLike(String value) {
            addCriterion("leadSourceDesc like", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescNotLike(String value) {
            addCriterion("leadSourceDesc not like", value, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescIn(List<String> values) {
            addCriterion("leadSourceDesc in", values, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescNotIn(List<String> values) {
            addCriterion("leadSourceDesc not in", values, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescBetween(String value1, String value2) {
            addCriterion("leadSourceDesc between", value1, value2, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andLeadsourcedescNotBetween(String value1, String value2) {
            addCriterion("leadSourceDesc not between", value1, value2, "leadsourcedesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescIsNull() {
            addCriterion("statusDesc is null");
            return (Criteria) this;
        }

        public Criteria andStatusdescIsNotNull() {
            addCriterion("statusDesc is not null");
            return (Criteria) this;
        }

        public Criteria andStatusdescEqualTo(String value) {
            addCriterion("statusDesc =", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescNotEqualTo(String value) {
            addCriterion("statusDesc <>", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescGreaterThan(String value) {
            addCriterion("statusDesc >", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescGreaterThanOrEqualTo(String value) {
            addCriterion("statusDesc >=", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescLessThan(String value) {
            addCriterion("statusDesc <", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescLessThanOrEqualTo(String value) {
            addCriterion("statusDesc <=", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescLike(String value) {
            addCriterion("statusDesc like", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescNotLike(String value) {
            addCriterion("statusDesc not like", value, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescIn(List<String> values) {
            addCriterion("statusDesc in", values, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescNotIn(List<String> values) {
            addCriterion("statusDesc not in", values, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescBetween(String value1, String value2) {
            addCriterion("statusDesc between", value1, value2, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andStatusdescNotBetween(String value1, String value2) {
            addCriterion("statusDesc not between", value1, value2, "statusdesc");
            return (Criteria) this;
        }

        public Criteria andReferredbyIsNull() {
            addCriterion("referredBy is null");
            return (Criteria) this;
        }

        public Criteria andReferredbyIsNotNull() {
            addCriterion("referredBy is not null");
            return (Criteria) this;
        }

        public Criteria andReferredbyEqualTo(String value) {
            addCriterion("referredBy =", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyNotEqualTo(String value) {
            addCriterion("referredBy <>", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyGreaterThan(String value) {
            addCriterion("referredBy >", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyGreaterThanOrEqualTo(String value) {
            addCriterion("referredBy >=", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyLessThan(String value) {
            addCriterion("referredBy <", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyLessThanOrEqualTo(String value) {
            addCriterion("referredBy <=", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyLike(String value) {
            addCriterion("referredBy like", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyNotLike(String value) {
            addCriterion("referredBy not like", value, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyIn(List<String> values) {
            addCriterion("referredBy in", values, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyNotIn(List<String> values) {
            addCriterion("referredBy not in", values, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyBetween(String value1, String value2) {
            addCriterion("referredBy between", value1, value2, "referredby");
            return (Criteria) this;
        }

        public Criteria andReferredbyNotBetween(String value1, String value2) {
            addCriterion("referredBy not between", value1, value2, "referredby");
            return (Criteria) this;
        }

        public Criteria andPrefixnameIsNull() {
            addCriterion("prefixName is null");
            return (Criteria) this;
        }

        public Criteria andPrefixnameIsNotNull() {
            addCriterion("prefixName is not null");
            return (Criteria) this;
        }

        public Criteria andPrefixnameEqualTo(String value) {
            addCriterion("prefixName =", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameNotEqualTo(String value) {
            addCriterion("prefixName <>", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameGreaterThan(String value) {
            addCriterion("prefixName >", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameGreaterThanOrEqualTo(String value) {
            addCriterion("prefixName >=", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameLessThan(String value) {
            addCriterion("prefixName <", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameLessThanOrEqualTo(String value) {
            addCriterion("prefixName <=", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameLike(String value) {
            addCriterion("prefixName like", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameNotLike(String value) {
            addCriterion("prefixName not like", value, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameIn(List<String> values) {
            addCriterion("prefixName in", values, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameNotIn(List<String> values) {
            addCriterion("prefixName not in", values, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameBetween(String value1, String value2) {
            addCriterion("prefixName between", value1, value2, "prefixname");
            return (Criteria) this;
        }

        public Criteria andPrefixnameNotBetween(String value1, String value2) {
            addCriterion("prefixName not between", value1, value2, "prefixname");
            return (Criteria) this;
        }

        public Criteria andFirstnameIsNull() {
            addCriterion("firstname is null");
            return (Criteria) this;
        }

        public Criteria andFirstnameIsNotNull() {
            addCriterion("firstname is not null");
            return (Criteria) this;
        }

        public Criteria andFirstnameEqualTo(String value) {
            addCriterion("firstname =", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameNotEqualTo(String value) {
            addCriterion("firstname <>", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameGreaterThan(String value) {
            addCriterion("firstname >", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameGreaterThanOrEqualTo(String value) {
            addCriterion("firstname >=", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameLessThan(String value) {
            addCriterion("firstname <", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameLessThanOrEqualTo(String value) {
            addCriterion("firstname <=", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameLike(String value) {
            addCriterion("firstname like", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameNotLike(String value) {
            addCriterion("firstname not like", value, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameIn(List<String> values) {
            addCriterion("firstname in", values, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameNotIn(List<String> values) {
            addCriterion("firstname not in", values, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameBetween(String value1, String value2) {
            addCriterion("firstname between", value1, value2, "firstname");
            return (Criteria) this;
        }

        public Criteria andFirstnameNotBetween(String value1, String value2) {
            addCriterion("firstname not between", value1, value2, "firstname");
            return (Criteria) this;
        }

        public Criteria andLastnameIsNull() {
            addCriterion("lastname is null");
            return (Criteria) this;
        }

        public Criteria andLastnameIsNotNull() {
            addCriterion("lastname is not null");
            return (Criteria) this;
        }

        public Criteria andLastnameEqualTo(String value) {
            addCriterion("lastname =", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameNotEqualTo(String value) {
            addCriterion("lastname <>", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameGreaterThan(String value) {
            addCriterion("lastname >", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameGreaterThanOrEqualTo(String value) {
            addCriterion("lastname >=", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameLessThan(String value) {
            addCriterion("lastname <", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameLessThanOrEqualTo(String value) {
            addCriterion("lastname <=", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameLike(String value) {
            addCriterion("lastname like", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameNotLike(String value) {
            addCriterion("lastname not like", value, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameIn(List<String> values) {
            addCriterion("lastname in", values, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameNotIn(List<String> values) {
            addCriterion("lastname not in", values, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameBetween(String value1, String value2) {
            addCriterion("lastname between", value1, value2, "lastname");
            return (Criteria) this;
        }

        public Criteria andLastnameNotBetween(String value1, String value2) {
            addCriterion("lastname not between", value1, value2, "lastname");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNull() {
            addCriterion("accountName is null");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNotNull() {
            addCriterion("accountName is not null");
            return (Criteria) this;
        }

        public Criteria andAccountnameEqualTo(String value) {
            addCriterion("accountName =", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotEqualTo(String value) {
            addCriterion("accountName <>", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThan(String value) {
            addCriterion("accountName >", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThanOrEqualTo(String value) {
            addCriterion("accountName >=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThan(String value) {
            addCriterion("accountName <", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThanOrEqualTo(String value) {
            addCriterion("accountName <=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLike(String value) {
            addCriterion("accountName like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotLike(String value) {
            addCriterion("accountName not like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameIn(List<String> values) {
            addCriterion("accountName in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotIn(List<String> values) {
            addCriterion("accountName not in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameBetween(String value1, String value2) {
            addCriterion("accountName between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotBetween(String value1, String value2) {
            addCriterion("accountName not between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andTitleIsNull() {
            addCriterion("title is null");
            return (Criteria) this;
        }

        public Criteria andTitleIsNotNull() {
            addCriterion("title is not null");
            return (Criteria) this;
        }

        public Criteria andTitleEqualTo(String value) {
            addCriterion("title =", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotEqualTo(String value) {
            addCriterion("title <>", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThan(String value) {
            addCriterion("title >", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleGreaterThanOrEqualTo(String value) {
            addCriterion("title >=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThan(String value) {
            addCriterion("title <", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLessThanOrEqualTo(String value) {
            addCriterion("title <=", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleLike(String value) {
            addCriterion("title like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotLike(String value) {
            addCriterion("title not like", value, "title");
            return (Criteria) this;
        }

        public Criteria andTitleIn(List<String> values) {
            addCriterion("title in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotIn(List<String> values) {
            addCriterion("title not in", values, "title");
            return (Criteria) this;
        }

        public Criteria andTitleBetween(String value1, String value2) {
            addCriterion("title between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andTitleNotBetween(String value1, String value2) {
            addCriterion("title not between", value1, value2, "title");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNull() {
            addCriterion("department is null");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNotNull() {
            addCriterion("department is not null");
            return (Criteria) this;
        }

        public Criteria andDepartmentEqualTo(String value) {
            addCriterion("department =", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotEqualTo(String value) {
            addCriterion("department <>", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThan(String value) {
            addCriterion("department >", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("department >=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThan(String value) {
            addCriterion("department <", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThanOrEqualTo(String value) {
            addCriterion("department <=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLike(String value) {
            addCriterion("department like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotLike(String value) {
            addCriterion("department not like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentIn(List<String> values) {
            addCriterion("department in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotIn(List<String> values) {
            addCriterion("department not in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentBetween(String value1, String value2) {
            addCriterion("department between", value1, value2, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotBetween(String value1, String value2) {
            addCriterion("department not between", value1, value2, "department");
            return (Criteria) this;
        }

        public Criteria andIscallableIsNull() {
            addCriterion("isCallable is null");
            return (Criteria) this;
        }

        public Criteria andIscallableIsNotNull() {
            addCriterion("isCallable is not null");
            return (Criteria) this;
        }

        public Criteria andIscallableEqualTo(Boolean value) {
            addCriterion("isCallable =", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableNotEqualTo(Boolean value) {
            addCriterion("isCallable <>", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableGreaterThan(Boolean value) {
            addCriterion("isCallable >", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableGreaterThanOrEqualTo(Boolean value) {
            addCriterion("isCallable >=", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableLessThan(Boolean value) {
            addCriterion("isCallable <", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableLessThanOrEqualTo(Boolean value) {
            addCriterion("isCallable <=", value, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableIn(List<Boolean> values) {
            addCriterion("isCallable in", values, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableNotIn(List<Boolean> values) {
            addCriterion("isCallable not in", values, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableBetween(Boolean value1, Boolean value2) {
            addCriterion("isCallable between", value1, value2, "iscallable");
            return (Criteria) this;
        }

        public Criteria andIscallableNotBetween(Boolean value1, Boolean value2) {
            addCriterion("isCallable not between", value1, value2, "iscallable");
            return (Criteria) this;
        }

        public Criteria andOfficephoneIsNull() {
            addCriterion("officePhone is null");
            return (Criteria) this;
        }

        public Criteria andOfficephoneIsNotNull() {
            addCriterion("officePhone is not null");
            return (Criteria) this;
        }

        public Criteria andOfficephoneEqualTo(String value) {
            addCriterion("officePhone =", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneNotEqualTo(String value) {
            addCriterion("officePhone <>", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneGreaterThan(String value) {
            addCriterion("officePhone >", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneGreaterThanOrEqualTo(String value) {
            addCriterion("officePhone >=", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneLessThan(String value) {
            addCriterion("officePhone <", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneLessThanOrEqualTo(String value) {
            addCriterion("officePhone <=", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneLike(String value) {
            addCriterion("officePhone like", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneNotLike(String value) {
            addCriterion("officePhone not like", value, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneIn(List<String> values) {
            addCriterion("officePhone in", values, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneNotIn(List<String> values) {
            addCriterion("officePhone not in", values, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneBetween(String value1, String value2) {
            addCriterion("officePhone between", value1, value2, "officephone");
            return (Criteria) this;
        }

        public Criteria andOfficephoneNotBetween(String value1, String value2) {
            addCriterion("officePhone not between", value1, value2, "officephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneIsNull() {
            addCriterion("homePhone is null");
            return (Criteria) this;
        }

        public Criteria andHomephoneIsNotNull() {
            addCriterion("homePhone is not null");
            return (Criteria) this;
        }

        public Criteria andHomephoneEqualTo(String value) {
            addCriterion("homePhone =", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneNotEqualTo(String value) {
            addCriterion("homePhone <>", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneGreaterThan(String value) {
            addCriterion("homePhone >", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneGreaterThanOrEqualTo(String value) {
            addCriterion("homePhone >=", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneLessThan(String value) {
            addCriterion("homePhone <", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneLessThanOrEqualTo(String value) {
            addCriterion("homePhone <=", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneLike(String value) {
            addCriterion("homePhone like", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneNotLike(String value) {
            addCriterion("homePhone not like", value, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneIn(List<String> values) {
            addCriterion("homePhone in", values, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneNotIn(List<String> values) {
            addCriterion("homePhone not in", values, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneBetween(String value1, String value2) {
            addCriterion("homePhone between", value1, value2, "homephone");
            return (Criteria) this;
        }

        public Criteria andHomephoneNotBetween(String value1, String value2) {
            addCriterion("homePhone not between", value1, value2, "homephone");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andOtherphoneIsNull() {
            addCriterion("otherPhone is null");
            return (Criteria) this;
        }

        public Criteria andOtherphoneIsNotNull() {
            addCriterion("otherPhone is not null");
            return (Criteria) this;
        }

        public Criteria andOtherphoneEqualTo(String value) {
            addCriterion("otherPhone =", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneNotEqualTo(String value) {
            addCriterion("otherPhone <>", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneGreaterThan(String value) {
            addCriterion("otherPhone >", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneGreaterThanOrEqualTo(String value) {
            addCriterion("otherPhone >=", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneLessThan(String value) {
            addCriterion("otherPhone <", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneLessThanOrEqualTo(String value) {
            addCriterion("otherPhone <=", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneLike(String value) {
            addCriterion("otherPhone like", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneNotLike(String value) {
            addCriterion("otherPhone not like", value, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneIn(List<String> values) {
            addCriterion("otherPhone in", values, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneNotIn(List<String> values) {
            addCriterion("otherPhone not in", values, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneBetween(String value1, String value2) {
            addCriterion("otherPhone between", value1, value2, "otherphone");
            return (Criteria) this;
        }

        public Criteria andOtherphoneNotBetween(String value1, String value2) {
            addCriterion("otherPhone not between", value1, value2, "otherphone");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andPrimaddressIsNull() {
            addCriterion("primAddress is null");
            return (Criteria) this;
        }

        public Criteria andPrimaddressIsNotNull() {
            addCriterion("primAddress is not null");
            return (Criteria) this;
        }

        public Criteria andPrimaddressEqualTo(String value) {
            addCriterion("primAddress =", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressNotEqualTo(String value) {
            addCriterion("primAddress <>", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressGreaterThan(String value) {
            addCriterion("primAddress >", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressGreaterThanOrEqualTo(String value) {
            addCriterion("primAddress >=", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressLessThan(String value) {
            addCriterion("primAddress <", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressLessThanOrEqualTo(String value) {
            addCriterion("primAddress <=", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressLike(String value) {
            addCriterion("primAddress like", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressNotLike(String value) {
            addCriterion("primAddress not like", value, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressIn(List<String> values) {
            addCriterion("primAddress in", values, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressNotIn(List<String> values) {
            addCriterion("primAddress not in", values, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressBetween(String value1, String value2) {
            addCriterion("primAddress between", value1, value2, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimaddressNotBetween(String value1, String value2) {
            addCriterion("primAddress not between", value1, value2, "primaddress");
            return (Criteria) this;
        }

        public Criteria andPrimstateIsNull() {
            addCriterion("primState is null");
            return (Criteria) this;
        }

        public Criteria andPrimstateIsNotNull() {
            addCriterion("primState is not null");
            return (Criteria) this;
        }

        public Criteria andPrimstateEqualTo(String value) {
            addCriterion("primState =", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateNotEqualTo(String value) {
            addCriterion("primState <>", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateGreaterThan(String value) {
            addCriterion("primState >", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateGreaterThanOrEqualTo(String value) {
            addCriterion("primState >=", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateLessThan(String value) {
            addCriterion("primState <", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateLessThanOrEqualTo(String value) {
            addCriterion("primState <=", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateLike(String value) {
            addCriterion("primState like", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateNotLike(String value) {
            addCriterion("primState not like", value, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateIn(List<String> values) {
            addCriterion("primState in", values, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateNotIn(List<String> values) {
            addCriterion("primState not in", values, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateBetween(String value1, String value2) {
            addCriterion("primState between", value1, value2, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimstateNotBetween(String value1, String value2) {
            addCriterion("primState not between", value1, value2, "primstate");
            return (Criteria) this;
        }

        public Criteria andPrimcityIsNull() {
            addCriterion("primCity is null");
            return (Criteria) this;
        }

        public Criteria andPrimcityIsNotNull() {
            addCriterion("primCity is not null");
            return (Criteria) this;
        }

        public Criteria andPrimcityEqualTo(String value) {
            addCriterion("primCity =", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityNotEqualTo(String value) {
            addCriterion("primCity <>", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityGreaterThan(String value) {
            addCriterion("primCity >", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityGreaterThanOrEqualTo(String value) {
            addCriterion("primCity >=", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityLessThan(String value) {
            addCriterion("primCity <", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityLessThanOrEqualTo(String value) {
            addCriterion("primCity <=", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityLike(String value) {
            addCriterion("primCity like", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityNotLike(String value) {
            addCriterion("primCity not like", value, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityIn(List<String> values) {
            addCriterion("primCity in", values, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityNotIn(List<String> values) {
            addCriterion("primCity not in", values, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityBetween(String value1, String value2) {
            addCriterion("primCity between", value1, value2, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimcityNotBetween(String value1, String value2) {
            addCriterion("primCity not between", value1, value2, "primcity");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeIsNull() {
            addCriterion("primPostalCode is null");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeIsNotNull() {
            addCriterion("primPostalCode is not null");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeEqualTo(String value) {
            addCriterion("primPostalCode =", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeNotEqualTo(String value) {
            addCriterion("primPostalCode <>", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeGreaterThan(String value) {
            addCriterion("primPostalCode >", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("primPostalCode >=", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeLessThan(String value) {
            addCriterion("primPostalCode <", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeLessThanOrEqualTo(String value) {
            addCriterion("primPostalCode <=", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeLike(String value) {
            addCriterion("primPostalCode like", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeNotLike(String value) {
            addCriterion("primPostalCode not like", value, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeIn(List<String> values) {
            addCriterion("primPostalCode in", values, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeNotIn(List<String> values) {
            addCriterion("primPostalCode not in", values, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeBetween(String value1, String value2) {
            addCriterion("primPostalCode between", value1, value2, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimpostalcodeNotBetween(String value1, String value2) {
            addCriterion("primPostalCode not between", value1, value2, "primpostalcode");
            return (Criteria) this;
        }

        public Criteria andPrimcountryIsNull() {
            addCriterion("primCountry is null");
            return (Criteria) this;
        }

        public Criteria andPrimcountryIsNotNull() {
            addCriterion("primCountry is not null");
            return (Criteria) this;
        }

        public Criteria andPrimcountryEqualTo(String value) {
            addCriterion("primCountry =", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryNotEqualTo(String value) {
            addCriterion("primCountry <>", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryGreaterThan(String value) {
            addCriterion("primCountry >", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryGreaterThanOrEqualTo(String value) {
            addCriterion("primCountry >=", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryLessThan(String value) {
            addCriterion("primCountry <", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryLessThanOrEqualTo(String value) {
            addCriterion("primCountry <=", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryLike(String value) {
            addCriterion("primCountry like", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryNotLike(String value) {
            addCriterion("primCountry not like", value, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryIn(List<String> values) {
            addCriterion("primCountry in", values, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryNotIn(List<String> values) {
            addCriterion("primCountry not in", values, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryBetween(String value1, String value2) {
            addCriterion("primCountry between", value1, value2, "primcountry");
            return (Criteria) this;
        }

        public Criteria andPrimcountryNotBetween(String value1, String value2) {
            addCriterion("primCountry not between", value1, value2, "primcountry");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNull() {
            addCriterion("createdTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNotNull() {
            addCriterion("createdTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeEqualTo(Date value) {
            addCriterion("createdTime =", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotEqualTo(Date value) {
            addCriterion("createdTime <>", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThan(Date value) {
            addCriterion("createdTime >", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createdTime >=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThan(Date value) {
            addCriterion("createdTime <", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("createdTime <=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIn(List<Date> values) {
            addCriterion("createdTime in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotIn(List<Date> values) {
            addCriterion("createdTime not in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeBetween(Date value1, Date value2) {
            addCriterion("createdTime between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("createdTime not between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNull() {
            addCriterion("createdUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNotNull() {
            addCriterion("createdUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateduserEqualTo(String value) {
            addCriterion("createdUser =", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotEqualTo(String value) {
            addCriterion("createdUser <>", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThan(String value) {
            addCriterion("createdUser >", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThanOrEqualTo(String value) {
            addCriterion("createdUser >=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThan(String value) {
            addCriterion("createdUser <", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThanOrEqualTo(String value) {
            addCriterion("createdUser <=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLike(String value) {
            addCriterion("createdUser like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotLike(String value) {
            addCriterion("createdUser not like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserIn(List<String> values) {
            addCriterion("createdUser in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotIn(List<String> values) {
            addCriterion("createdUser not in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserBetween(String value1, String value2) {
            addCriterion("createdUser between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotBetween(String value1, String value2) {
            addCriterion("createdUser not between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNull() {
            addCriterion("sAccountId is null");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNotNull() {
            addCriterion("sAccountId is not null");
            return (Criteria) this;
        }

        public Criteria andSaccountidEqualTo(Integer value) {
            addCriterion("sAccountId =", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotEqualTo(Integer value) {
            addCriterion("sAccountId <>", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThan(Integer value) {
            addCriterion("sAccountId >", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThanOrEqualTo(Integer value) {
            addCriterion("sAccountId >=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThan(Integer value) {
            addCriterion("sAccountId <", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThanOrEqualTo(Integer value) {
            addCriterion("sAccountId <=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidIn(List<Integer> values) {
            addCriterion("sAccountId in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotIn(List<Integer> values) {
            addCriterion("sAccountId not in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId not between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNull() {
            addCriterion("assignUser is null");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNotNull() {
            addCriterion("assignUser is not null");
            return (Criteria) this;
        }

        public Criteria andAssignuserEqualTo(String value) {
            addCriterion("assignUser =", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotEqualTo(String value) {
            addCriterion("assignUser <>", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThan(String value) {
            addCriterion("assignUser >", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThanOrEqualTo(String value) {
            addCriterion("assignUser >=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThan(String value) {
            addCriterion("assignUser <", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThanOrEqualTo(String value) {
            addCriterion("assignUser <=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLike(String value) {
            addCriterion("assignUser like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotLike(String value) {
            addCriterion("assignUser not like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserIn(List<String> values) {
            addCriterion("assignUser in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotIn(List<String> values) {
            addCriterion("assignUser not in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserBetween(String value1, String value2) {
            addCriterion("assignUser between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotBetween(String value1, String value2) {
            addCriterion("assignUser not between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("source like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("source not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNull() {
            addCriterion("website is null");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNotNull() {
            addCriterion("website is not null");
            return (Criteria) this;
        }

        public Criteria andWebsiteEqualTo(String value) {
            addCriterion("website =", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotEqualTo(String value) {
            addCriterion("website <>", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThan(String value) {
            addCriterion("website >", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThanOrEqualTo(String value) {
            addCriterion("website >=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThan(String value) {
            addCriterion("website <", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThanOrEqualTo(String value) {
            addCriterion("website <=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLike(String value) {
            addCriterion("website like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotLike(String value) {
            addCriterion("website not like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteIn(List<String> values) {
            addCriterion("website in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotIn(List<String> values) {
            addCriterion("website not in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteBetween(String value1, String value2) {
            addCriterion("website between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotBetween(String value1, String value2) {
            addCriterion("website not between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andOtheraddressIsNull() {
            addCriterion("otherAddress is null");
            return (Criteria) this;
        }

        public Criteria andOtheraddressIsNotNull() {
            addCriterion("otherAddress is not null");
            return (Criteria) this;
        }

        public Criteria andOtheraddressEqualTo(String value) {
            addCriterion("otherAddress =", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressNotEqualTo(String value) {
            addCriterion("otherAddress <>", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressGreaterThan(String value) {
            addCriterion("otherAddress >", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressGreaterThanOrEqualTo(String value) {
            addCriterion("otherAddress >=", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressLessThan(String value) {
            addCriterion("otherAddress <", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressLessThanOrEqualTo(String value) {
            addCriterion("otherAddress <=", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressLike(String value) {
            addCriterion("otherAddress like", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressNotLike(String value) {
            addCriterion("otherAddress not like", value, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressIn(List<String> values) {
            addCriterion("otherAddress in", values, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressNotIn(List<String> values) {
            addCriterion("otherAddress not in", values, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressBetween(String value1, String value2) {
            addCriterion("otherAddress between", value1, value2, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtheraddressNotBetween(String value1, String value2) {
            addCriterion("otherAddress not between", value1, value2, "otheraddress");
            return (Criteria) this;
        }

        public Criteria andOtherstateIsNull() {
            addCriterion("otherState is null");
            return (Criteria) this;
        }

        public Criteria andOtherstateIsNotNull() {
            addCriterion("otherState is not null");
            return (Criteria) this;
        }

        public Criteria andOtherstateEqualTo(String value) {
            addCriterion("otherState =", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateNotEqualTo(String value) {
            addCriterion("otherState <>", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateGreaterThan(String value) {
            addCriterion("otherState >", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateGreaterThanOrEqualTo(String value) {
            addCriterion("otherState >=", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateLessThan(String value) {
            addCriterion("otherState <", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateLessThanOrEqualTo(String value) {
            addCriterion("otherState <=", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateLike(String value) {
            addCriterion("otherState like", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateNotLike(String value) {
            addCriterion("otherState not like", value, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateIn(List<String> values) {
            addCriterion("otherState in", values, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateNotIn(List<String> values) {
            addCriterion("otherState not in", values, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateBetween(String value1, String value2) {
            addCriterion("otherState between", value1, value2, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOtherstateNotBetween(String value1, String value2) {
            addCriterion("otherState not between", value1, value2, "otherstate");
            return (Criteria) this;
        }

        public Criteria andOthercityIsNull() {
            addCriterion("otherCity is null");
            return (Criteria) this;
        }

        public Criteria andOthercityIsNotNull() {
            addCriterion("otherCity is not null");
            return (Criteria) this;
        }

        public Criteria andOthercityEqualTo(String value) {
            addCriterion("otherCity =", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityNotEqualTo(String value) {
            addCriterion("otherCity <>", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityGreaterThan(String value) {
            addCriterion("otherCity >", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityGreaterThanOrEqualTo(String value) {
            addCriterion("otherCity >=", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityLessThan(String value) {
            addCriterion("otherCity <", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityLessThanOrEqualTo(String value) {
            addCriterion("otherCity <=", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityLike(String value) {
            addCriterion("otherCity like", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityNotLike(String value) {
            addCriterion("otherCity not like", value, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityIn(List<String> values) {
            addCriterion("otherCity in", values, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityNotIn(List<String> values) {
            addCriterion("otherCity not in", values, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityBetween(String value1, String value2) {
            addCriterion("otherCity between", value1, value2, "othercity");
            return (Criteria) this;
        }

        public Criteria andOthercityNotBetween(String value1, String value2) {
            addCriterion("otherCity not between", value1, value2, "othercity");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeIsNull() {
            addCriterion("otherPostalCode is null");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeIsNotNull() {
            addCriterion("otherPostalCode is not null");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeEqualTo(String value) {
            addCriterion("otherPostalCode =", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeNotEqualTo(String value) {
            addCriterion("otherPostalCode <>", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeGreaterThan(String value) {
            addCriterion("otherPostalCode >", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("otherPostalCode >=", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeLessThan(String value) {
            addCriterion("otherPostalCode <", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeLessThanOrEqualTo(String value) {
            addCriterion("otherPostalCode <=", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeLike(String value) {
            addCriterion("otherPostalCode like", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeNotLike(String value) {
            addCriterion("otherPostalCode not like", value, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeIn(List<String> values) {
            addCriterion("otherPostalCode in", values, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeNotIn(List<String> values) {
            addCriterion("otherPostalCode not in", values, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeBetween(String value1, String value2) {
            addCriterion("otherPostalCode between", value1, value2, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOtherpostalcodeNotBetween(String value1, String value2) {
            addCriterion("otherPostalCode not between", value1, value2, "otherpostalcode");
            return (Criteria) this;
        }

        public Criteria andOthercountryIsNull() {
            addCriterion("otherCountry is null");
            return (Criteria) this;
        }

        public Criteria andOthercountryIsNotNull() {
            addCriterion("otherCountry is not null");
            return (Criteria) this;
        }

        public Criteria andOthercountryEqualTo(String value) {
            addCriterion("otherCountry =", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryNotEqualTo(String value) {
            addCriterion("otherCountry <>", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryGreaterThan(String value) {
            addCriterion("otherCountry >", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryGreaterThanOrEqualTo(String value) {
            addCriterion("otherCountry >=", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryLessThan(String value) {
            addCriterion("otherCountry <", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryLessThanOrEqualTo(String value) {
            addCriterion("otherCountry <=", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryLike(String value) {
            addCriterion("otherCountry like", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryNotLike(String value) {
            addCriterion("otherCountry not like", value, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryIn(List<String> values) {
            addCriterion("otherCountry in", values, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryNotIn(List<String> values) {
            addCriterion("otherCountry not in", values, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryBetween(String value1, String value2) {
            addCriterion("otherCountry between", value1, value2, "othercountry");
            return (Criteria) this;
        }

        public Criteria andOthercountryNotBetween(String value1, String value2) {
            addCriterion("otherCountry not between", value1, value2, "othercountry");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNull() {
            addCriterion("industry is null");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNotNull() {
            addCriterion("industry is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryEqualTo(String value) {
            addCriterion("industry =", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotEqualTo(String value) {
            addCriterion("industry <>", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThan(String value) {
            addCriterion("industry >", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("industry >=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThan(String value) {
            addCriterion("industry <", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThanOrEqualTo(String value) {
            addCriterion("industry <=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLike(String value) {
            addCriterion("industry like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotLike(String value) {
            addCriterion("industry not like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryIn(List<String> values) {
            addCriterion("industry in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotIn(List<String> values) {
            addCriterion("industry not in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryBetween(String value1, String value2) {
            addCriterion("industry between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotBetween(String value1, String value2) {
            addCriterion("industry not between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNull() {
            addCriterion("lastUpdatedTime is null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNotNull() {
            addCriterion("lastUpdatedTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeEqualTo(Date value) {
            addCriterion("lastUpdatedTime =", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotEqualTo(Date value) {
            addCriterion("lastUpdatedTime <>", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThan(Date value) {
            addCriterion("lastUpdatedTime >", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime >=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThan(Date value) {
            addCriterion("lastUpdatedTime <", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime <=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIn(List<Date> values) {
            addCriterion("lastUpdatedTime in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotIn(List<Date> values) {
            addCriterion("lastUpdatedTime not in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime not between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andNoemployeesIsNull() {
            addCriterion("noEmployees is null");
            return (Criteria) this;
        }

        public Criteria andNoemployeesIsNotNull() {
            addCriterion("noEmployees is not null");
            return (Criteria) this;
        }

        public Criteria andNoemployeesEqualTo(Integer value) {
            addCriterion("noEmployees =", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesNotEqualTo(Integer value) {
            addCriterion("noEmployees <>", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesGreaterThan(Integer value) {
            addCriterion("noEmployees >", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesGreaterThanOrEqualTo(Integer value) {
            addCriterion("noEmployees >=", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesLessThan(Integer value) {
            addCriterion("noEmployees <", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesLessThanOrEqualTo(Integer value) {
            addCriterion("noEmployees <=", value, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesIn(List<Integer> values) {
            addCriterion("noEmployees in", values, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesNotIn(List<Integer> values) {
            addCriterion("noEmployees not in", values, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesBetween(Integer value1, Integer value2) {
            addCriterion("noEmployees between", value1, value2, "noemployees");
            return (Criteria) this;
        }

        public Criteria andNoemployeesNotBetween(Integer value1, Integer value2) {
            addCriterion("noEmployees not between", value1, value2, "noemployees");
            return (Criteria) this;
        }

        public Criteria andAvataridIsNull() {
            addCriterion("avatarId is null");
            return (Criteria) this;
        }

        public Criteria andAvataridIsNotNull() {
            addCriterion("avatarId is not null");
            return (Criteria) this;
        }

        public Criteria andAvataridEqualTo(String value) {
            addCriterion("avatarId =", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotEqualTo(String value) {
            addCriterion("avatarId <>", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridGreaterThan(String value) {
            addCriterion("avatarId >", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridGreaterThanOrEqualTo(String value) {
            addCriterion("avatarId >=", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLessThan(String value) {
            addCriterion("avatarId <", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLessThanOrEqualTo(String value) {
            addCriterion("avatarId <=", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLike(String value) {
            addCriterion("avatarId like", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotLike(String value) {
            addCriterion("avatarId not like", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridIn(List<String> values) {
            addCriterion("avatarId in", values, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotIn(List<String> values) {
            addCriterion("avatarId not in", values, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridBetween(String value1, String value2) {
            addCriterion("avatarId between", value1, value2, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotBetween(String value1, String value2) {
            addCriterion("avatarId not between", value1, value2, "avatarid");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_lead
     *
     * @mbg.generated do_not_delete_during_merge Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_lead
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}